﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace Syx.Webapi.AppCode.Entities {

	[JsonObject(MemberSerialization.OptIn), Table(Name = "JK_SJ_BB_HL", DisableSyncStructure = true)]
	public partial class JKSJBBHL {

		[JsonProperty, Column(DbType = "VARCHAR2(20 BYTE)")]
		public string AGE { get; set; }

		[JsonProperty, Column(Name = "CHECK_NO", DbType = "VARCHAR2(50 BYTE)")]
		public string CHECKNO { get; set; }

		[JsonProperty, Column(Name = "CREATE_DATE", DbType = "DATE(7)")]
		public DateTime? CREATEDATE { get; set; }

		[JsonProperty, Column(Name = "DEPT_CODE", DbType = "VARCHAR2(50 BYTE)")]
		public string DEPTCODE { get; set; }

		[JsonProperty, Column(Name = "DEPT_NAME", DbType = "VARCHAR2(50 BYTE)")]
		public string DEPTNAME { get; set; }

		[JsonProperty, Column(Name = "FLAG_JGS")]
		public int? FLAGJGS { get; set; }

		[JsonProperty, Column(Name = "FLAG_NCG")]
		public sbyte? FLAGNCG { get; set; }

		[JsonProperty, Column(Name = "FLAG_XCG")]
		public sbyte? FLAGXCG { get; set; }

		[JsonProperty]
		public sbyte? ISSELECT { get; set; }

		[JsonProperty]
		public sbyte? ISYANG { get; set; }

		[JsonProperty, Column(Name = "ITEM_CODE", DbType = "VARCHAR2(50 BYTE)")]
		public string ITEMCODE { get; set; }

		[JsonProperty, Column(Name = "ITEM_NAME", DbType = "VARCHAR2(200 BYTE)")]
		public string ITEMNAME { get; set; }

		[JsonProperty, Column(Name = "ITEM_TYPE")]
		public int? ITEMTYPE { get; set; }

		[JsonProperty, Column(Name = "ITEM_TYPE_NAME", DbType = "VARCHAR2(1000 BYTE)")]
		public string ITEMTYPENAME { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(50 BYTE)")]
		public string NAME { get; set; }

		[JsonProperty, Column(Name = "PATIENT_ID", DbType = "VARCHAR2(50 BYTE)")]
		public string PATIENTID { get; set; }

		[JsonProperty, Column(Name = "SEND_DATE", DbType = "DATE(7)")]
		public DateTime? SENDDATE { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(4 BYTE)")]
		public string SEX { get; set; }

		[JsonProperty, Column(Name = "TAB_ID", DbType = "NUMBER(22)")]
		public decimal TABID { get; set; }

		[JsonProperty, Column(Name = "TEST_NO", DbType = "VARCHAR2(100 BYTE)")]
		public string TESTNO { get; set; }

		[JsonProperty, Column(Name = "VISIT_ID")]
		public int? VISITID { get; set; }

		[JsonProperty]
		public int XH { get; set; }

		[JsonProperty]
		public int? ZBXH { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(50 BYTE)")]
		public string ZYID { get; set; }

	}

}
